<?php
  // Tmweb MAPs
  require_once dirname(__FILE__)."/../purin2/alter/alter.php";

  // drop or clear
  puSql("drop table tmap");
  puDelete("delete from tmap");

  // create table
  puSql("
  create table tmap (
    i_tmap integer auto_increment not null, -- serial
    v_name varchar(50) character set utf8 collate utf8_general_ci not null,            -- map name
    v_filename varchar(50) character set utf8 collate utf8_general_ci not null,        -- map filename
    primary key (i_tmap)
  )");

  // index
  puSql("create unique index p_tmap_1 on tmap (i_tmap)");
  puSql("create unique index s_tmap_1 on tmap (v_name)");
  puSql("create unique index s_tmap_2 on tmap (v_filename)");
?>